Senior Data Modeler
Kansas City, MO
Summary:
The Senior Data Modeler is responsible for designing, developing, and optimizing semantic models that enable robust reporting, analytics, and data products.
Key Responsibilities:
- Design and implement semantic models using PowerBI and transition SSAS to PowerBI.
- Build models by working with various data platforms, predominantly Databricks and SQL Server.
- Responsible for enhancing model and query performance and partnering with data engineers to design tables for optimal performance.
- Document data models, mappings, and business rules using Alation and other tooling.
- Work with stakeholders to elicit requirements, and mentor junior data modelers and data engineers using BI tooling.
- Provide leadership, guidance, and instruction to less experienced staff.
- Responsible for QA/QC adherence.
- Responsible for compliance with company and site safety policies
- Performs other duties as assigned.
- Compliance with all policies and standards.
Requirements:
- A bachelor’s degree in computer science, management information systems, engineering, or a related field and 8 years of experience in data modeling with a focus on PowerBI or SSAS are required.
- Advanced knowledge of AQL, DAX, and M Query.
- Familiarity with semantic layer platforms is highly desirable.
- Solid understanding of database design principles, data warehousing concepts, and ETL/ELT processes.
- Experience with cloud environments like Azure.
- Strong attention to detail, facilitation, team building, collaboration, organization, and problem-solving skills.
- Excellent verbal and written communication skills.
- Ability to work methodically and analytically in a quantitative problem-solving environment.
- Demonstrated critical thinking skills.